SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE procedure dbo.[DnnProduct_DeleteTabPermissionsByUserID]
	@PortalID int,
	@UserID int
AS
	DELETE FROM dbo.DnnProduct_TabPermission
		FROM dbo.DnnProduct_TabPermission TP
			INNER JOIN dbo.DnnProduct_Tabs AS T ON TP.TabID = T.TabID
		WHERE T.PortalID = @PortalID
		AND TP.UserID = @UserID
GO
